Course Description:

This is the first course in database management systems. You will learn (1)
how to design and create relational databases, (2) how to use SQL on
relational databases, and (3) how to build a relational database. You will
also learn some advance topics, such as transaction management, query
optimization, etc. This course emphasizes on students`s hands-on learning.
This means that there will be some programming assignments which students
will implement several components of a relational database system.

This course is taught in English.

Prerequisite:

- Data structure and algorithms
- Proficiency in C++ programming

Required Textbook:

- `Database Management Systems, Third Edition` by Ramakrishnan and Gehrke.


Database Systems
- course description
This is an introductory course on database systems. This course will cover
the following topics: the entity-relationship model, the relational data
models, SQL languages, relational algebra and calculus, query evaluation and
optimization, storage and indexing, security and authorization, transaction
management, concurrency control, fault tolerance, and crash recovery. Since
this is a computer science course, this course will place more emphasis on
how to build modern database systems, rather than how to use commercial
database systems. Students are encouraged to take a complementary
project-course `practicum in database systems` that teaches how to build a
simple database system. The difference between these two courses is that
this course will teach you `concepts` of database systems, whereas the
practicum course will teach you how to actually program a real database
system. This course will be taught in English.
- course prerequisite:
Data structure and algorithms.
C++ programming
- required textbook
Database Management Systems, Third Edition” by Ramakrishnan and Gehrke.